package com.dao.wmsdao;

import java.sql.SQLException;
import java.util.List;

import com.bean.wms.OrderDetail;
import com.bean.wms.Orders;


public interface OrdersDao {
	
	public Orders getOrdersByExternOrderskey(String wareHourse, String key , String storerkey) throws SQLException;
	
	public void insertOrders(Orders orders) throws SQLException;
	
	public void updateOrders(Orders orders) throws SQLException;
	
	public List<Orders> getOrdersByStatus(String status , String susr1 , String susr3);
	
	public List<Orders> getOrdersCancelByStatus(String susr1 , String susr3 , String cancelmark , String cancelcomplete);
	
	public void insertOrderDetail(OrderDetail orderDetail) throws SQLException;
	
	public void updateOrderDetail(OrderDetail orderDetail) throws SQLException;
	
	public void insertComOrders(Orders orders) throws SQLException;
	
	public void insertRecordByList(final List<Orders> ordersList) throws SQLException;
	
	public void deleteOrderDetailByOrderKey(String wareHourse , String orderKey , String externOrderKey) throws SQLException;
}
